Program taking a lot of time ..... needs optimization [message #36774] |
Wed, 19 December 2001 17:24 |
Vamsi
Messages: 9 Registered: December 2001
|
Junior Member |
|
|
Hi,
I have a pl/sql procedure that inserts data into a table. I have to insert about 40000 records into the table. Each new record inserted is based on the previous values present in the table, so that one of the fields is unique throughout.
so before each insert a full table scan is made for checking if the same value exists or not. So, for 20000 records the program takes about 50 mins. Can we cut down this execution time by any means?
TIA,
Vamsi.
----------------------------------------------------------------------
|
|
|
|